2016-08-02 - 27769 - Break Fix - COGS values missing in Query #BExQueriesforCrystalReportsAnalysisTool

Break Fix

27769 - COGS missing value in Query

Problem Summary

Need to identify reason for missing COGS value in ZEM_BPC_Q020 BEx Query.

Admin Info

Purpose
 Need to identify reason for missing COGS value in ZEM_BPC_Q020 BEx Query
Requested by
 Sara Overhaff
Issue Date
 08-02-2016
Resolved by
 Naveen Gadde
Resolved Date
 08-02-2016
Document Status
 Complete

Detailed Problem Description

Email from Jayson Osmars on 07/29/2016:
It’s been discovered missing values in the first 4 periods for COGS in the BEx query ZEM_BPC_Q020:
Can we quickly have a look?
2016-11-14_17-40-12.jpg

Solution Analysis and Recommendations
The BEx formula for 'COGS-TY Shipped' is updated with OPA(open) CKF instead of COPA CKF, due to this reason COGS TY shipped is showing blank values. The formula in BEx Query needs to be changed to fix the issue.

Resolution

Updating the 'COGS-TY Shipped' with COPA CKF will fix the issue.

Release Information

2016-08-02 - 27769 - Rel Notes - COGS missing values in Query